CREATE OR REPLACE TRIGGER MELEE_WEAPON_RULES_TRIGGER
BEFORE INSERT ON MELEE_WEAPON_RULES
FOR EACH ROW WHEN (NEW.MELEE_WEAPON_RULE_ID IS NULL)
BEGIN 
	SELECT MELEE_WEAPON_RULES_ID_SEQUENCE.NEXTVAL 
	INTO :NEW.MELEE_WEAPON_RULE_ID 
	FROM DUAL;
END;